Skip to main content

How to change/Apply Alias of column in Pipeline

What is Group Condition?

  • Group Condition is a process in which we split data into group by applying some conditions on datasets.

Objective

  • By following this document user will know how to create Group Condition in Pipeline.

Prerequisites

  • For this example we are using Sales.ds.

  • Download dependency file from this link. After downloading the file, extract if and upload Sales.ds from file into the OPNBI.

Skill Level Required

  • Good to have basic knowledge of pipeline. Click here to know more about pipeline in detail.

Steps to Create Group Conditin in Pipeline

  1. Log in to your OpnBI application using your valid credentils.

  2. There are two ways by which user can go to the Pipeline Section.

I. By selecting hamburger menu Docusaurus Slash Introduction > MasterData > Data Pipeline.

Docusaurus Slash Introduction

II. By selecting hamburger menu Docusaurus Slash Introduction > MasterData > Dataset Section.

Docusaurus Slash Introduction

  1. Click on Create Pipeline from the bottom menu tollbar. As shownn in the figure below:

    Docusaurus Slash Introduction

  2. Go to the Pipeline section by selectng any option given above, & one blank create pipeline window will open.

  3. Enter the following detils in the pipeline dialog box:

  • Name: Group Condition Pipeline
  1. Find Sales.ds from the Search box as shown:

    Docusaurus Slash Introduction

  2. Drag and Drop Sales.ds to the right side & select all the columns from the Select Column dialog box, as shown in the figure below:

    Docusaurus Slash Introduction

  3. Click on submit button, After submitting, the diagram box will look like the figure below:

    Docusaurus Slash Introduction

  4. Click on Add Condition button as shown in image below:

    Docusaurus Slash Introduction

  5. As you click on Add Condition one window will shown as shown below:

    Docusaurus Slash Introduction

  6. Select OR & click on (+) icon, then select Add Group, as shown in the image below:

    Docusaurus Slash Introduction

  7. As you click on Add Group, one group is added as shown:

    Docusaurus Slash Introduction

  8. Click on (╳) icon, as shown in image above.

  9. Fill the details as shown in image below:

    Docusaurus Slash Introduction

  10. Now Click on (+) icon to add a new AND condition as shown:

    Docusaurus Slash Introduction

  11. Fill the details as shown:

    Docusaurus Slash Introduction

  12. Now, Add a new Group & make a condition in refrence to the step 11 & step 14 respwcctively. Then, Fill the details as shown:

    Docusaurus Slash Introduction

  13. Now, again add a new Group & make a condition in refrence to the step 11 & step 14 respwcctively. Then, Fill the details as shown:

    Docusaurus Slash Introduction

  14. Click on GET CONDITION button.

  15. & Click on Submit button & your pipeline dataset is created successfully.

  16. Now, click on hamburger menu Docusaurus Slash Introduction > Document > Adhoc Analysis & click on the + icon to create a new Analysis, as shown in the figure below:

    Docusaurus Slash Introduction

  17. When you click on create Analysis then the Analysis Selection dialog box will open, as shown in the figure below:

    Docusaurus Slash Introduction

  18. In create Analysis fill the details as shown:

  • Datasets: Sales.ds
  • Rows: COUNTRY
  • Colummns: PRODUCTLINE
  • Values: QUANTITYORDERED
  • Type: Sum

Docusaurus Slash Introduction

  1. Click on PREVIEW & CANCEL button.

  2. Your Analysis widget will look as per the image below:

    Docusaurus Slash Introduction

  3. Give the name of Analysis.

  • Name: Pipeline Group Condition
  1. Click on Save as Docusaurus Slash Introduction icon for saving the Analysis, it will show the screen as below:

    Docusaurus Slash Introduction

  2. Give the name of Analysis.

  3. Name: Group Condition Pipeline & Select the folder where you want to save Analysis, as shown in the figure below:

    Docusaurus Slash Introduction

  4. Click on Save As button.